| SyOrganization |
| EntityType | Independent |
| Logical Entity Name | SyOrganization |
| Default Table Name | SyOrganization |
| Logical Only | NO |
| Owner | dbo |
| Definition | |
| Note |
| SyOrganization Attributes |
| Attribute/Logical Rolename | Domain | Datatype | NULL | Definition |
SyOrganizationId |
INTEGER | NO | ||
| Code | CHAR(16) | NO | ||
| Name | VARCHAR(60) | NO | ||
| StreetAddress | VARCHAR(255) | YES | ||
| City | CHAR(35) | YES | ||
| State | CHAR(2) | YES | ||
| PostalCode | CHAR(10) | YES | ||
CountryId |
INTEGER | YES | ||
| PhoneNumber | VARCHAR(16) | YES | ||
| FaxNumber | VARCHAR(16) | YES | ||
| Note | VARCHAR(2000) | YES | ||
| IsActive | BIT | NO | ||
CountyId |
INTEGER | YES | ||
| EmailAddress | VARCHAR(50) | YES | ||
| URL | VARCHAR(50) | YES | ||
OrganizationTypeId |
INTEGER | NO | ||
CampusGroupId |
INTEGER | YES | ||
ContactStaffId |
INTEGER | YES | ||
LastModifiedUserId |
INTEGER | NO | ||
| CreatedDateTime | DATETIME | NO | ||
| LastModifiedDateTime | DATETIME | NO | ||
| RowVersion | TIMESTAMP/DATE | NO | ||
| IsExcludedCrmIntegration | BIT | NO | ||
StaffId |
INTEGER | YES |
| SyOrganization Keys |
| Key Name | Key Type | Keys |
| SyOrganization_UserID_N_N_IDX | Inversion Entry | LastModifiedUserId |
| SyOrganization_SyCampusGrpID_N_N_IDX | Inversion Entry | CampusGroupId |
| SyOrganization_SyOrganizationTypeID_N_N_IDX | Inversion Entry | OrganizationTypeId |
| SyOrganization_SyCountyID_N_N_IDX | Inversion Entry | CountyId |
| SyOrganization_SyCountryID_N_N_IDX | Inversion Entry | CountryId |
| SyOrganization_OrgLiaisionId_N_N_IDX | Inversion Entry | ContactStaffId |
| PK_SyOrganization_SyOrganizationID | PrimaryKey | SyOrganizationId |
| SyOrganization Relationships |
| Parent Relationships: |
| Entity Name | Type | Cardinality | Business Name | VerbPhrase | InversePhrase | Foreign Keys | Is Supertype |
| Staff | Non-Identifying | Zero or One to Zero or More | StaffId | NO | |||
| Staff | Non-Identifying | Zero or One to Zero or More | ContactStaffId | NO | |||
| CampusGroup | Non-Identifying | Zero or One to Zero or More | CampusGroupId | NO | |||
| Country | Non-Identifying | Zero or One to Zero or More | CountryId | NO | |||
| County | Non-Identifying | Zero or One to Zero or More | CountyId | NO | |||
| OrganizationType | Non-Identifying | One To Zero or More | OrganizationTypeId | NO | |||
| Staff | Non-Identifying | One To Zero or More | LastModifiedUserId | NO | |||
| OrganizationType | Non-Identifying | Zero or One to Zero or More | OrganizationTypeId | NO |
| Child Relationships: |
| Entity Name | Type | Cardinality | Business Name | VerbPhrase | InversePhrase | Foreign Keys | Is Subtype |
| HighSchool | Non-Identifying | One To Zero or More | NO | ||||
| LeadSourceExpense | Non-Identifying | One To Zero or More | NO | ||||
| LeadSourceLeadVendor | Non-Identifying | One To Zero or More | NO | ||||
| LeadVendor | Non-Identifying | One To Zero or More | NO | ||||
| LeadSubVendor | Non-Identifying | One To Zero or More | NO | ||||
| LeadSubVendor | Non-Identifying | One To Zero or More | NO | ||||
| ProspectInquiryLeadSourceLeadVendor | Non-Identifying | One To Zero or More | NO | ||||
| Task | Non-Identifying | One To Zero or More | NO | ||||
| TaskArchive | Non-Identifying | One To Zero or More | NO | ||||
| SyOrganizationContact | Non-Identifying | One To Zero or More | NO | ||||
| StudentHighSchoolContact | Non-Identifying | One To Zero or More | NO | ||||
| HighSchool | Non-Identifying | One To Zero or More | NO | ||||
| StudentHighSchoolContact | Non-Identifying | One To Zero or More | NO | ||||
| SyOrganizationContact | Non-Identifying | One To Zero or More | NO | ||||
| Task | Non-Identifying | One To Zero or More | NO | ||||
| TaskArchive | Non-Identifying | One To Zero or More | NO |
| SyOrganization Check Constraints |
| Check Constraint Name | CheckConstraint |
| SyOrganization Where Used - Model Usage |
| Mapped Object | Is User Defined? | Denormalization Mappings | Description | Bound Attachments |
| Logical dbo.SyOrganization |
NO | |||
| Physical (Microsoft SQL Server) dbo.SyOrganization |
NO |
| SyOrganization Where Used - Submodel Usage |
| Model | Submodel Usage |
| Logical | Main Model |
| Logical | Tasks |
| Physical (Microsoft SQL Server) | Main Model |
| Physical (Microsoft SQL Server) | System |
| SyOrganization Data Movement Rules |
| Name | Type | Rule Text/Value |